﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PCV_TutorialDataSet" targetNamespace="http://tempuri.org/PCV_TutorialDataSet.xsd" xmlns:mstns="http://tempuri.org/PCV_TutorialDataSet.xsd" xmlns="http://tempuri.org/PCV_TutorialDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="PCV_TutorialConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="PCV_TutorialConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PCV_Tutorial.My.MySettings.GlobalReference.Default.PCV_TutorialConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ChaTableAdapter" GeneratorDataComponentClassName="ChaTableAdapter" Name="Cha" UserDataComponentName="ChaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_TutorialConnectionString (MySettings)" DbObjectName="PCV_Tutorial.dbo.Cha" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cha] WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_maphieu = 1 AND [maphieu] IS NULL) OR ([maphieu] = @Original_maphieu)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_nhomdanhmuc_ma = 1 AND [nhomdanhmuc_ma] IS NULL) OR ([nhomdanhmuc_ma] = @Original_nhomdanhmuc_ma)) AND ((@IsNull_nhomdanhmuc_maid = 1 AND [nhomdanhmuc_maid] IS NULL) OR ([nhomdanhmuc_maid] = @Original_nhomdanhmuc_maid)) AND ((@IsNull_nhomdanhmuc_ten = 1 AND [nhomdanhmuc_ten] IS NULL) OR ([nhomdanhmuc_ten] = @Original_nhomdanhmuc_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maphieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maphieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maphieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhomdanhmuc_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_nhomdanhmuc_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhomdanhmuc_maid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomdanhmuc_maid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhomdanhmuc_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhomdanhmuc_maid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhomdanhmuc_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhomdanhmuc_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cha] ([ma], [maphieu], [ngay], [nhomdanhmuc_ma], [nhomdanhmuc_maid], [nhomdanhmuc_ten], [ghichu]) VALUES (@ma, @maphieu, @ngay, @nhomdanhmuc_ma, @nhomdanhmuc_maid, @nhomdanhmuc_ten, @ghichu);
SELECT ma, maphieu, ngay, nhomdanhmuc_ma, nhomdanhmuc_maid, nhomdanhmuc_ten, ghichu, id FROM Cha WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maphieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@nhomdanhmuc_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhomdanhmuc_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhomdanhmuc_maid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhomdanhmuc_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, maphieu, ngay, nhomdanhmuc_ma, nhomdanhmuc_maid, nhomdanhmuc_ten, ghichu, id FROM dbo.Cha</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cha] SET [ma] = @ma, [maphieu] = @maphieu, [ngay] = @ngay, [nhomdanhmuc_ma] = @nhomdanhmuc_ma, [nhomdanhmuc_maid] = @nhomdanhmuc_maid, [nhomdanhmuc_ten] = @nhomdanhmuc_ten, [ghichu] = @ghichu WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_maphieu = 1 AND [maphieu] IS NULL) OR ([maphieu] = @Original_maphieu)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_nhomdanhmuc_ma = 1 AND [nhomdanhmuc_ma] IS NULL) OR ([nhomdanhmuc_ma] = @Original_nhomdanhmuc_ma)) AND ((@IsNull_nhomdanhmuc_maid = 1 AND [nhomdanhmuc_maid] IS NULL) OR ([nhomdanhmuc_maid] = @Original_nhomdanhmuc_maid)) AND ((@IsNull_nhomdanhmuc_ten = 1 AND [nhomdanhmuc_ten] IS NULL) OR ([nhomdanhmuc_ten] = @Original_nhomdanhmuc_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ([id] = @Original_id));
SELECT ma, maphieu, ngay, nhomdanhmuc_ma, nhomdanhmuc_maid, nhomdanhmuc_ten, ghichu, id FROM Cha WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maphieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@nhomdanhmuc_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhomdanhmuc_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhomdanhmuc_maid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhomdanhmuc_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maphieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maphieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maphieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maphieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhomdanhmuc_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_nhomdanhmuc_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhomdanhmuc_maid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomdanhmuc_maid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhomdanhmuc_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhomdanhmuc_maid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhomdanhmuc_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhomdanhmuc_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhomdanhmuc_ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="maphieu" DataSetColumn="maphieu" />
              <Mapping SourceColumn="ngay" DataSetColumn="ngay" />
              <Mapping SourceColumn="nhomdanhmuc_ma" DataSetColumn="nhomdanhmuc_ma" />
              <Mapping SourceColumn="nhomdanhmuc_maid" DataSetColumn="nhomdanhmuc_maid" />
              <Mapping SourceColumn="nhomdanhmuc_ten" DataSetColumn="nhomdanhmuc_ten" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DanhMucTableAdapter" GeneratorDataComponentClassName="DanhMucTableAdapter" Name="DanhMuc" UserDataComponentName="DanhMucTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_TutorialConnectionString (MySettings)" DbObjectName="PCV_Tutorial.dbo.DanhMuc" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DanhMuc] WHERE (([ma] = @Original_ma) AND ((@IsNull_maid = 1 AND [maid] IS NULL) OR ([maid] = @Original_maid)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_nhom = 1 AND [nhom] IS NULL) OR ([nhom] = @Original_nhom)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_gia = 1 AND [gia] IS NULL) OR ([gia] = @Original_gia)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DanhMuc] ([ma], [maid], [ten], [nhom], [ngay], [gia], [chietkhau], [ghichu]) VALUES (@ma, @maid, @ten, @nhom, @ngay, @gia, @chietkhau, @ghichu);
SELECT ma, maid, ten, nhom, ngay, gia, chietkhau, ghichu, id FROM DanhMuc WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, maid, ten, nhom, ngay, gia, chietkhau, ghichu, id FROM dbo.DanhMuc</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DanhMuc] SET [ma] = @ma, [maid] = @maid, [ten] = @ten, [nhom] = @nhom, [ngay] = @ngay, [gia] = @gia, [chietkhau] = @chietkhau, [ghichu] = @ghichu WHERE (([ma] = @Original_ma) AND ((@IsNull_maid = 1 AND [maid] IS NULL) OR ([maid] = @Original_maid)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_nhom = 1 AND [nhom] IS NULL) OR ([nhom] = @Original_nhom)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_gia = 1 AND [gia] IS NULL) OR ([gia] = @Original_gia)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ([id] = @Original_id));
SELECT ma, maid, ten, nhom, ngay, gia, chietkhau, ghichu, id FROM DanhMuc WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nhom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nhom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nhom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nhom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nhom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="gia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="maid" DataSetColumn="maid" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="nhom" DataSetColumn="nhom" />
              <Mapping SourceColumn="ngay" DataSetColumn="ngay" />
              <Mapping SourceColumn="gia" DataSetColumn="gia" />
              <Mapping SourceColumn="chietkhau" DataSetColumn="chietkhau" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PCV_TutorialConnectionString (MySettings)" DbObjectName="PCV_Tutorial.dbo.FindDanhMucTuNgayDenNgay" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.FindDanhMucTuNgayDenNgay</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@tungay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@denngay" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NhomDanhMucTableAdapter" GeneratorDataComponentClassName="NhomDanhMucTableAdapter" Name="NhomDanhMuc" UserDataComponentName="NhomDanhMucTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_TutorialConnectionString (MySettings)" DbObjectName="PCV_Tutorial.dbo.NhomDanhMuc" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[NhomDanhMuc] WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_maid = 1 AND [maid] IS NULL) OR ([maid] = @Original_maid)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[NhomDanhMuc] ([ma], [maid], [ten], [ghichu]) VALUES (@ma, @maid, @ten, @ghichu);
SELECT ma, maid, ten, ghichu, id FROM NhomDanhMuc WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, maid, ten, ghichu, id FROM dbo.NhomDanhMuc</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[NhomDanhMuc] SET [ma] = @ma, [maid] = @maid, [ten] = @ten, [ghichu] = @ghichu WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_maid = 1 AND [maid] IS NULL) OR ([maid] = @Original_maid)) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ([id] = @Original_id));
SELECT ma, maid, ten, ghichu, id FROM NhomDanhMuc WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="maid" DataSetColumn="maid" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ThongTinTableAdapter" GeneratorDataComponentClassName="ThongTinTableAdapter" Name="ThongTin" UserDataComponentName="ThongTinTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_TutorialConnectionString (MySettings)" DbObjectName="PCV_Tutorial.dbo.ThongTin" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ThongTin] WHERE (([ma] = @Original_ma) AND ([ma_id] = @Original_ma_id) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_diachiweb = 1 AND [diachiweb] IS NULL) OR ([diachiweb] = @Original_diachiweb)) AND ((@IsNull_giamdoc = 1 AND [giamdoc] IS NULL) OR ([giamdoc] = @Original_giamdoc)) AND ((@IsNull_ketoantruong = 1 AND [ketoantruong] IS NULL) OR ([ketoantruong] = @Original_ketoantruong)) AND ((@IsNull_chon = 1 AND [chon] IS NULL) OR ([chon] = @Original_chon)) AND ([trangthai] = @Original_trangthai) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma_id" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachiweb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachiweb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachiweb" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachiweb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giamdoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giamdoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_giamdoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="giamdoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ketoantruong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ketoantruong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ketoantruong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ketoantruong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_chon" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="chon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_trangthai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="trangthai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ThongTin] ([ma], [ma_id], [ten], [diachi], [dienthoai], [fax], [email], [masothue], [diachiweb], [logo], [giamdoc], [ketoantruong], [chon], [trangthai]) VALUES (@ma, @ma_id, @ten, @diachi, @dienthoai, @fax, @email, @masothue, @diachiweb, @logo, @giamdoc, @ketoantruong, @chon, @trangthai);
SELECT ma, ma_id, ten, diachi, dienthoai, fax, email, masothue, diachiweb, logo, giamdoc, ketoantruong, chon, trangthai, id FROM ThongTin WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma_id" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachiweb" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachiweb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@giamdoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="giamdoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ketoantruong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ketoantruong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@chon" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="chon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@trangthai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="trangthai" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ma_id, ten, diachi, dienthoai, fax, email, masothue, diachiweb, logo, giamdoc, ketoantruong, chon, trangthai, id FROM dbo.ThongTin</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ThongTin] SET [ma] = @ma, [ma_id] = @ma_id, [ten] = @ten, [diachi] = @diachi, [dienthoai] = @dienthoai, [fax] = @fax, [email] = @email, [masothue] = @masothue, [diachiweb] = @diachiweb, [logo] = @logo, [giamdoc] = @giamdoc, [ketoantruong] = @ketoantruong, [chon] = @chon, [trangthai] = @trangthai WHERE (([ma] = @Original_ma) AND ([ma_id] = @Original_ma_id) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_masothue = 1 AND [masothue] IS NULL) OR ([masothue] = @Original_masothue)) AND ((@IsNull_diachiweb = 1 AND [diachiweb] IS NULL) OR ([diachiweb] = @Original_diachiweb)) AND ((@IsNull_giamdoc = 1 AND [giamdoc] IS NULL) OR ([giamdoc] = @Original_giamdoc)) AND ((@IsNull_ketoantruong = 1 AND [ketoantruong] IS NULL) OR ([ketoantruong] = @Original_ketoantruong)) AND ((@IsNull_chon = 1 AND [chon] IS NULL) OR ([chon] = @Original_chon)) AND ([trangthai] = @Original_trangthai) AND ([id] = @Original_id));
SELECT ma, ma_id, ten, diachi, dienthoai, fax, email, masothue, diachiweb, logo, giamdoc, ketoantruong, chon, trangthai, id FROM ThongTin WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma_id" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachiweb" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachiweb" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@giamdoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="giamdoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ketoantruong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ketoantruong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@chon" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="chon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@trangthai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="trangthai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma_id" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_masothue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_masothue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="masothue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachiweb" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachiweb" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachiweb" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachiweb" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giamdoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giamdoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_giamdoc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="giamdoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ketoantruong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ketoantruong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ketoantruong" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ketoantruong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_chon" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="chon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_trangthai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="trangthai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="numeric" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ma_id" DataSetColumn="ma_id" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="dienthoai" DataSetColumn="dienthoai" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="masothue" DataSetColumn="masothue" />
              <Mapping SourceColumn="diachiweb" DataSetColumn="diachiweb" />
              <Mapping SourceColumn="logo" DataSetColumn="logo" />
              <Mapping SourceColumn="giamdoc" DataSetColumn="giamdoc" />
              <Mapping SourceColumn="ketoantruong" DataSetColumn="ketoantruong" />
              <Mapping SourceColumn="chon" DataSetColumn="chon" />
              <Mapping SourceColumn="trangthai" DataSetColumn="trangthai" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ConTableAdapter" GeneratorDataComponentClassName="ConTableAdapter" Name="Con" UserDataComponentName="ConTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PCV_TutorialConnectionString (MySettings)" DbObjectName="PCV_Tutorial.dbo.Con" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Con] WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_cha_maphieu = 1 AND [cha_maphieu] IS NULL) OR ([cha_maphieu] = @Original_cha_maphieu)) AND ((@IsNull_cha_ngay = 1 AND [cha_ngay] IS NULL) OR ([cha_ngay] = @Original_cha_ngay)) AND ((@IsNull_danhmuc_ma = 1 AND [danhmuc_ma] IS NULL) OR ([danhmuc_ma] = @Original_danhmuc_ma)) AND ((@IsNull_danhmuc_maid = 1 AND [danhmuc_maid] IS NULL) OR ([danhmuc_maid] = @Original_danhmuc_maid)) AND ((@IsNull_danhmuc_ten = 1 AND [danhmuc_ten] IS NULL) OR ([danhmuc_ten] = @Original_danhmuc_ten)) AND ((@IsNull_soluong = 1 AND [soluong] IS NULL) OR ([soluong] = @Original_soluong)) AND ((@IsNull_danhmuc_gia = 1 AND [danhmuc_gia] IS NULL) OR ([danhmuc_gia] = @Original_danhmuc_gia)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_thanhtien = 1 AND [thanhtien] IS NULL) OR ([thanhtien] = @Original_thanhtien)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cha_maphieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cha_maphieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cha_maphieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cha_maphieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cha_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cha_ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_cha_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="cha_ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_danhmuc_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="danhmuc_ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_danhmuc_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="danhmuc_ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_danhmuc_maid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="danhmuc_maid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_danhmuc_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="danhmuc_maid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_danhmuc_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="danhmuc_ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_danhmuc_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="danhmuc_ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_danhmuc_gia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="danhmuc_gia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_danhmuc_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="danhmuc_gia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Con] ([ma], [cha_maphieu], [cha_ngay], [danhmuc_ma], [danhmuc_maid], [danhmuc_ten], [soluong], [danhmuc_gia], [chietkhau], [thanhtien], [ghichu], [uid]) VALUES (@ma, @cha_maphieu, @cha_ngay, @danhmuc_ma, @danhmuc_maid, @danhmuc_ten, @soluong, @danhmuc_gia, @chietkhau, @thanhtien, @ghichu, @uid);
SELECT ma, cha_maphieu, cha_ngay, danhmuc_ma, danhmuc_maid, danhmuc_ten, soluong, danhmuc_gia, chietkhau, thanhtien, ghichu, uid, id FROM Con WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cha_maphieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cha_maphieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@cha_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="cha_ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@danhmuc_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="danhmuc_ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@danhmuc_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="danhmuc_maid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@danhmuc_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="danhmuc_ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@danhmuc_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="danhmuc_gia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, cha_maphieu, cha_ngay, danhmuc_ma, danhmuc_maid, danhmuc_ten, soluong, danhmuc_gia, chietkhau, thanhtien, ghichu, uid, id FROM dbo.Con</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Con] SET [ma] = @ma, [cha_maphieu] = @cha_maphieu, [cha_ngay] = @cha_ngay, [danhmuc_ma] = @danhmuc_ma, [danhmuc_maid] = @danhmuc_maid, [danhmuc_ten] = @danhmuc_ten, [soluong] = @soluong, [danhmuc_gia] = @danhmuc_gia, [chietkhau] = @chietkhau, [thanhtien] = @thanhtien, [ghichu] = @ghichu, [uid] = @uid WHERE (((@IsNull_ma = 1 AND [ma] IS NULL) OR ([ma] = @Original_ma)) AND ((@IsNull_cha_maphieu = 1 AND [cha_maphieu] IS NULL) OR ([cha_maphieu] = @Original_cha_maphieu)) AND ((@IsNull_cha_ngay = 1 AND [cha_ngay] IS NULL) OR ([cha_ngay] = @Original_cha_ngay)) AND ((@IsNull_danhmuc_ma = 1 AND [danhmuc_ma] IS NULL) OR ([danhmuc_ma] = @Original_danhmuc_ma)) AND ((@IsNull_danhmuc_maid = 1 AND [danhmuc_maid] IS NULL) OR ([danhmuc_maid] = @Original_danhmuc_maid)) AND ((@IsNull_danhmuc_ten = 1 AND [danhmuc_ten] IS NULL) OR ([danhmuc_ten] = @Original_danhmuc_ten)) AND ((@IsNull_soluong = 1 AND [soluong] IS NULL) OR ([soluong] = @Original_soluong)) AND ((@IsNull_danhmuc_gia = 1 AND [danhmuc_gia] IS NULL) OR ([danhmuc_gia] = @Original_danhmuc_gia)) AND ((@IsNull_chietkhau = 1 AND [chietkhau] IS NULL) OR ([chietkhau] = @Original_chietkhau)) AND ((@IsNull_thanhtien = 1 AND [thanhtien] IS NULL) OR ([thanhtien] = @Original_thanhtien)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_uid = 1 AND [uid] IS NULL) OR ([uid] = @Original_uid)) AND ([id] = @Original_id));
SELECT ma, cha_maphieu, cha_ngay, danhmuc_ma, danhmuc_maid, danhmuc_ten, soluong, danhmuc_gia, chietkhau, thanhtien, ghichu, uid, id FROM Con WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cha_maphieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cha_maphieu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@cha_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="cha_ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@danhmuc_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="danhmuc_ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@danhmuc_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="danhmuc_maid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@danhmuc_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="danhmuc_ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@danhmuc_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="danhmuc_gia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cha_maphieu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cha_maphieu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cha_maphieu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cha_maphieu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cha_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cha_ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_cha_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="cha_ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_danhmuc_ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="danhmuc_ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_danhmuc_ma" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="danhmuc_ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_danhmuc_maid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="danhmuc_maid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_danhmuc_maid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="danhmuc_maid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_danhmuc_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="danhmuc_ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_danhmuc_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="danhmuc_ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_danhmuc_gia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="danhmuc_gia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_danhmuc_gia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="danhmuc_gia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_chietkhau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chietkhau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="PCV_Tutorial.dbo.Con" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="cha_maphieu" DataSetColumn="cha_maphieu" />
              <Mapping SourceColumn="cha_ngay" DataSetColumn="cha_ngay" />
              <Mapping SourceColumn="danhmuc_ma" DataSetColumn="danhmuc_ma" />
              <Mapping SourceColumn="danhmuc_maid" DataSetColumn="danhmuc_maid" />
              <Mapping SourceColumn="danhmuc_ten" DataSetColumn="danhmuc_ten" />
              <Mapping SourceColumn="soluong" DataSetColumn="soluong" />
              <Mapping SourceColumn="danhmuc_gia" DataSetColumn="danhmuc_gia" />
              <Mapping SourceColumn="chietkhau" DataSetColumn="chietkhau" />
              <Mapping SourceColumn="thanhtien" DataSetColumn="thanhtien" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PCV_TutorialDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="PCV_TutorialDataSet" msprop:Generator_UserDSName="PCV_TutorialDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cha" msprop:Generator_TableClassName="ChaDataTable" msprop:Generator_TableVarName="tableCha" msprop:Generator_TablePropName="Cha" msprop:Generator_RowDeletingName="ChaRowDeleting" msprop:Generator_RowChangingName="ChaRowChanging" msprop:Generator_RowEvHandlerName="ChaRowChangeEventHandler" msprop:Generator_RowDeletedName="ChaRowDeleted" msprop:Generator_UserTableName="Cha" msprop:Generator_RowChangedName="ChaRowChanged" msprop:Generator_RowEvArgName="ChaRowChangeEvent" msprop:Generator_RowClassName="ChaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maphieu" msprop:Generator_ColumnVarNameInTable="columnmaphieu" msprop:Generator_ColumnPropNameInRow="maphieu" msprop:Generator_ColumnPropNameInTable="maphieuColumn" msprop:Generator_UserColumnName="maphieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngay" msprop:Generator_ColumnVarNameInTable="columnngay" msprop:Generator_ColumnPropNameInRow="ngay" msprop:Generator_ColumnPropNameInTable="ngayColumn" msprop:Generator_UserColumnName="ngay" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nhomdanhmuc_ma" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnnhomdanhmuc_ma" msprop:Generator_ColumnPropNameInRow="nhomdanhmuc_ma" msprop:Generator_ColumnPropNameInTable="nhomdanhmuc_maColumn" msprop:Generator_UserColumnName="nhomdanhmuc_ma" type="xs:string" minOccurs="0" />
              <xs:element name="nhomdanhmuc_maid" msprop:Generator_ColumnVarNameInTable="columnnhomdanhmuc_maid" msprop:Generator_ColumnPropNameInRow="nhomdanhmuc_maid" msprop:Generator_ColumnPropNameInTable="nhomdanhmuc_maidColumn" msprop:Generator_UserColumnName="nhomdanhmuc_maid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nhomdanhmuc_ten" msprop:Generator_ColumnVarNameInTable="columnnhomdanhmuc_ten" msprop:Generator_ColumnPropNameInRow="nhomdanhmuc_ten" msprop:Generator_ColumnPropNameInTable="nhomdanhmuc_tenColumn" msprop:Generator_UserColumnName="nhomdanhmuc_ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DanhMuc" msprop:Generator_TableClassName="DanhMucDataTable" msprop:Generator_TableVarName="tableDanhMuc" msprop:Generator_TablePropName="DanhMuc" msprop:Generator_RowDeletingName="DanhMucRowDeleting" msprop:Generator_RowChangingName="DanhMucRowChanging" msprop:Generator_RowEvHandlerName="DanhMucRowChangeEventHandler" msprop:Generator_RowDeletedName="DanhMucRowDeleted" msprop:Generator_UserTableName="DanhMuc" msprop:Generator_RowChangedName="DanhMucRowChanged" msprop:Generator_RowEvArgName="DanhMucRowChangeEvent" msprop:Generator_RowClassName="DanhMucRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" type="xs:string" />
              <xs:element name="maid" msprop:Generator_ColumnVarNameInTable="columnmaid" msprop:Generator_ColumnPropNameInRow="maid" msprop:Generator_ColumnPropNameInTable="maidColumn" msprop:Generator_UserColumnName="maid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nhom" msprop:Generator_ColumnVarNameInTable="columnnhom" msprop:Generator_ColumnPropNameInRow="nhom" msprop:Generator_ColumnPropNameInTable="nhomColumn" msprop:Generator_UserColumnName="nhom" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngay" msprop:Generator_ColumnVarNameInTable="columnngay" msprop:Generator_ColumnPropNameInRow="ngay" msprop:Generator_ColumnPropNameInTable="ngayColumn" msprop:Generator_UserColumnName="ngay" type="xs:dateTime" minOccurs="0" />
              <xs:element name="gia" msprop:Generator_ColumnVarNameInTable="columngia" msprop:Generator_ColumnPropNameInRow="gia" msprop:Generator_ColumnPropNameInTable="giaColumn" msprop:Generator_UserColumnName="gia" type="xs:decimal" minOccurs="0" />
              <xs:element name="chietkhau" msprop:Generator_ColumnVarNameInTable="columnchietkhau" msprop:Generator_ColumnPropNameInRow="chietkhau" msprop:Generator_ColumnPropNameInTable="chietkhauColumn" msprop:Generator_UserColumnName="chietkhau" type="xs:int" minOccurs="0" />
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="NhomDanhMuc" msprop:Generator_TableClassName="NhomDanhMucDataTable" msprop:Generator_TableVarName="tableNhomDanhMuc" msprop:Generator_TablePropName="NhomDanhMuc" msprop:Generator_RowDeletingName="NhomDanhMucRowDeleting" msprop:Generator_RowChangingName="NhomDanhMucRowChanging" msprop:Generator_RowEvHandlerName="NhomDanhMucRowChangeEventHandler" msprop:Generator_RowDeletedName="NhomDanhMucRowDeleted" msprop:Generator_UserTableName="NhomDanhMuc" msprop:Generator_RowChangedName="NhomDanhMucRowChanged" msprop:Generator_RowEvArgName="NhomDanhMucRowChangeEvent" msprop:Generator_RowClassName="NhomDanhMucRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" type="xs:string" minOccurs="0" />
              <xs:element name="maid" msprop:Generator_ColumnVarNameInTable="columnmaid" msprop:Generator_ColumnPropNameInRow="maid" msprop:Generator_ColumnPropNameInTable="maidColumn" msprop:Generator_UserColumnName="maid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ThongTin" msprop:Generator_TableClassName="ThongTinDataTable" msprop:Generator_TableVarName="tableThongTin" msprop:Generator_TablePropName="ThongTin" msprop:Generator_RowDeletingName="ThongTinRowDeleting" msprop:Generator_RowChangingName="ThongTinRowChanging" msprop:Generator_RowEvHandlerName="ThongTinRowChangeEventHandler" msprop:Generator_RowDeletedName="ThongTinRowDeleted" msprop:Generator_UserTableName="ThongTin" msprop:Generator_RowChangedName="ThongTinRowChanged" msprop:Generator_RowEvArgName="ThongTinRowChangeEvent" msprop:Generator_RowClassName="ThongTinRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" type="xs:string" />
              <xs:element name="ma_id" msprop:Generator_ColumnVarNameInTable="columnma_id" msprop:Generator_ColumnPropNameInRow="ma_id" msprop:Generator_ColumnPropNameInTable="ma_idColumn" msprop:Generator_UserColumnName="ma_id">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai" msprop:Generator_ColumnVarNameInTable="columndienthoai" msprop:Generator_ColumnPropNameInRow="dienthoai" msprop:Generator_ColumnPropNameInTable="dienthoaiColumn" msprop:Generator_UserColumnName="dienthoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnPropNameInTable="faxColumn" msprop:Generator_UserColumnName="fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="masothue" msprop:Generator_ColumnVarNameInTable="columnmasothue" msprop:Generator_ColumnPropNameInRow="masothue" msprop:Generator_ColumnPropNameInTable="masothueColumn" msprop:Generator_UserColumnName="masothue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachiweb" msprop:Generator_ColumnVarNameInTable="columndiachiweb" msprop:Generator_ColumnPropNameInRow="diachiweb" msprop:Generator_ColumnPropNameInTable="diachiwebColumn" msprop:Generator_UserColumnName="diachiweb" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="logo" msprop:Generator_ColumnVarNameInTable="columnlogo" msprop:Generator_ColumnPropNameInRow="logo" msprop:Generator_ColumnPropNameInTable="logoColumn" msprop:Generator_UserColumnName="logo" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="giamdoc" msprop:Generator_ColumnVarNameInTable="columngiamdoc" msprop:Generator_ColumnPropNameInRow="giamdoc" msprop:Generator_ColumnPropNameInTable="giamdocColumn" msprop:Generator_UserColumnName="giamdoc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ketoantruong" msprop:Generator_ColumnVarNameInTable="columnketoantruong" msprop:Generator_ColumnPropNameInRow="ketoantruong" msprop:Generator_ColumnPropNameInTable="ketoantruongColumn" msprop:Generator_UserColumnName="ketoantruong" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chon" msprop:Generator_ColumnVarNameInTable="columnchon" msprop:Generator_ColumnPropNameInRow="chon" msprop:Generator_ColumnPropNameInTable="chonColumn" msprop:Generator_UserColumnName="chon" type="xs:boolean" minOccurs="0" />
              <xs:element name="trangthai" msprop:Generator_ColumnVarNameInTable="columntrangthai" msprop:Generator_ColumnPropNameInRow="trangthai" msprop:Generator_ColumnPropNameInTable="trangthaiColumn" msprop:Generator_UserColumnName="trangthai">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Con" msprop:Generator_TableClassName="ConDataTable" msprop:Generator_TableVarName="tableCon" msprop:Generator_RowChangedName="ConRowChanged" msprop:Generator_TablePropName="Con" msprop:Generator_RowDeletingName="ConRowDeleting" msprop:Generator_RowChangingName="ConRowChanging" msprop:Generator_RowEvHandlerName="ConRowChangeEventHandler" msprop:Generator_RowDeletedName="ConRowDeleted" msprop:Generator_RowClassName="ConRow" msprop:Generator_UserTableName="Con" msprop:Generator_RowEvArgName="ConRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cha_maphieu" msprop:Generator_ColumnVarNameInTable="columncha_maphieu" msprop:Generator_ColumnPropNameInRow="cha_maphieu" msprop:Generator_ColumnPropNameInTable="cha_maphieuColumn" msprop:Generator_UserColumnName="cha_maphieu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cha_ngay" msprop:Generator_ColumnVarNameInTable="columncha_ngay" msprop:Generator_ColumnPropNameInRow="cha_ngay" msprop:Generator_ColumnPropNameInTable="cha_ngayColumn" msprop:Generator_UserColumnName="cha_ngay" type="xs:dateTime" minOccurs="0" />
              <xs:element name="danhmuc_ma" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columndanhmuc_ma" msprop:Generator_ColumnPropNameInRow="danhmuc_ma" msprop:Generator_ColumnPropNameInTable="danhmuc_maColumn" msprop:Generator_UserColumnName="danhmuc_ma" type="xs:string" minOccurs="0" />
              <xs:element name="danhmuc_maid" msprop:Generator_ColumnVarNameInTable="columndanhmuc_maid" msprop:Generator_ColumnPropNameInRow="danhmuc_maid" msprop:Generator_ColumnPropNameInTable="danhmuc_maidColumn" msprop:Generator_UserColumnName="danhmuc_maid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="danhmuc_ten" msprop:Generator_ColumnVarNameInTable="columndanhmuc_ten" msprop:Generator_ColumnPropNameInRow="danhmuc_ten" msprop:Generator_ColumnPropNameInTable="danhmuc_tenColumn" msprop:Generator_UserColumnName="danhmuc_ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="soluong" msprop:Generator_ColumnVarNameInTable="columnsoluong" msprop:Generator_ColumnPropNameInRow="soluong" msprop:Generator_ColumnPropNameInTable="soluongColumn" msprop:Generator_UserColumnName="soluong" type="xs:decimal" minOccurs="0" />
              <xs:element name="danhmuc_gia" msprop:Generator_ColumnVarNameInTable="columndanhmuc_gia" msprop:Generator_ColumnPropNameInRow="danhmuc_gia" msprop:Generator_ColumnPropNameInTable="danhmuc_giaColumn" msprop:Generator_UserColumnName="danhmuc_gia" type="xs:decimal" minOccurs="0" />
              <xs:element name="chietkhau" msprop:Generator_ColumnVarNameInTable="columnchietkhau" msprop:Generator_ColumnPropNameInRow="chietkhau" msprop:Generator_ColumnPropNameInTable="chietkhauColumn" msprop:Generator_UserColumnName="chietkhau" type="xs:int" minOccurs="0" />
              <xs:element name="thanhtien" msprop:Generator_ColumnVarNameInTable="columnthanhtien" msprop:Generator_ColumnPropNameInRow="thanhtien" msprop:Generator_ColumnPropNameInTable="thanhtienColumn" msprop:Generator_UserColumnName="thanhtien" type="xs:decimal" minOccurs="0" />
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:Generator_UserColumnName="uid" type="xs:string" minOccurs="0" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cha" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="DanhMuc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DanhMuc" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="NhomDanhMuc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:NhomDanhMuc" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="ThongTin_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ThongTin" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Con_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Con" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Con_Con" msdata:parent="Cha" msdata:child="Con" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="Con" msprop:Generator_ChildPropName="GetConRows" msprop:Generator_UserRelationName="FK_Con_Con" msprop:Generator_RelationVarName="relationFK_Con_Con" msprop:Generator_UserParentTable="Cha" msprop:Generator_ParentPropName="ChaRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>